﻿USE SchoolManager;
IF OBJECT_ID (N'dbo.FacultyMember', N'U') IS NOT NULL
DROP TABLE dbo.FacultyMember;
CREATE TABLE [dbo].[FacultyMember] (    
    [UniqueID]   UNIQUEIDENTIFIER NOT NULL,
    [FirstName]  NVARCHAR (50)    NOT NULL,
    [LastName]   NVARCHAR (50)    NOT NULL,
    [Age]        INT              NOT NULL,
    [Salary]     MONEY            NULL    
);
ALTER TABLE [dbo].[FacultyMember]
    ADD CONSTRAINT [PK_Faculty] PRIMARY KEY CLUSTERED ([UniqueID] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF);



